SUPPORT / SAMPLES & SAS NOTES
Problem Note 47218: A "Read-Only Session Error" occurs when you use the SQL pass-through facility with SAS/ACCESS® Interface to Netezza
 |  |  |  |
When you use the SQL pass-through facility with SAS/ACCESS Interface to Netezza, the single connection submits several queries to the database management system (DBMS), and the following error might occur:
Here is an example of the code that might produce the error:
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
ERROR: CLI execute error: ERROR: CREATE TABLE AS SELECT not permitted in read-only session
The SQL pass-through facility has several queries that create Netezza temporary tables, a step to create a SAS data set, and another step to create a table in the Netezza DBMS.
Here is an example of the code that might produce the error:
proc sql;
connect to netezza (server=nzserver database=NZdb bulkunload=yes
user=NZUser password=NZPWD);
execute(create temporary table test1 as
select varone
from nztable)by netezza;
create tablework.all_cust as
select * from connection to netezza(
select varone from TEST1 );
execute(create temporary table test2 as
select distinct varone from test1
limit 100000 ) by netezza;
execute(create table nzdb.yyy_test3 as
select varone from test2
distribute on(varone))by netezza;
quit;
To work around this issue, create regular tables rather than temporary tables in the DBMS, or move the SELECT statement to the end of the program.
This behavior is fixed in SAS® 9.3.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Netezza | Windows 7 Professional 32 bit | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Home Premium x64 | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Home Premium 32 bit | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Enterprise x64 | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Enterprise 32 bit | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft® Windows® for x64 | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Professional x64 | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Ultimate x64 | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows Vista | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| 64-bit Enabled AIX | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| HP-UX IPF | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Linux | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Linux for x64 | 9.22 | 9.3 | 9.2 TS2M3 | 9.3 TS1M0 | ||